Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

gst_session table — gstss

This table records a session and is only applicable for the duration of a session. It records session activity and manages the context for the session in the child table, gsm_server_context.

Table 13–25 lists the table’s FLA, fields, and foreign keys.

Table 13–25: gst_session table information 

Table FLA	Fields (data type)	Foreign keys
gstss	session_obj (Decimal) session_id (Character) session_type_obj (Decimal) user_obj (Decimal) session_creation_date (Date) session_creation_time (Integer) last_access_date (Date) last_access_time (Integer) client_date_format (Character) client_numeric_format (Character) year_offset (Integer) session_complete (Logical) default_context_scope_obj (Decimal) render_type_obj (Decimal)	render_type_obj session_obj session_type_obj user_obj

Table 13–26 gives details of the table’s indexes.

Table 13–26: gst_session index information 

Index name	Elements	Type
XPKgst_session	session_obj	Primary Unique
XAK1gst_session	session_id	Unique
XIE1gst_session	session_type_obj	Nonunique
XIE2gst_session	user_obj	Nonunique
XIE3gst_session	last_access_date last_access_time	Nonunique
XIE5gst_session	session_complete	Nonunique
XIE6gst_session	default_context_scope_obj	Nonunique
XIE7gst_session	render_type_obj	Nonunique

The information in this table is all client related. In the case of a WebSpeed Agent, the agent is also the client.

The session id field from gsm_server_context table is now on this table, so the session id only exists in one place for the session. The object id for the session record is carried down onto the individual context records. This improves the efficiency of fixing the context id when a session is dropped and reconnected. That restores the context for the new session from the old session. For the AppServer, a record is created in this table at connection time and checked or updated in the activate procedure. To ensure that it updates as efficiently as possible, this table must not have a write trigger.